Full source code website bán hàng thương mại điện tử gần giống shopee
469.005 lượt xem;
1 <table height="28" cellSpacing="0" cellPadding="0" width="100%" border="0">
2 <tr align=center>
3 <td class="title" width="100%" height="17">
4 Danh mục đơn vị: <b> <a href="./?act=donvi_id_m&page=<? echo $_REQUEST['page']; ?>"><font color="#FFFFFF">Nhập
5 Mới</font></a><font color="#FFFFFF"> |</font></b></td>
6 </tr>
7 </table>
8 <?
9 switch ($_GET['action'])
10 {
11 case 'del' :
12 $id = $_GET['id'];
13 if (CountRecord("products","dv_id=".$id)<=0) {
14 @$result = mysql_query("delete from donvi where dv_id=".$id,$con);
15 if ($result) echo "<p align=center class='err'>Đã xóa thành công</p>";
16 else echo "<p align=center class='err'>Không thể xóa dữ liệu</p>";
17 } else {
18 echo "<p align=center class='err'>Đang có sản phẩm sử dụng đơn vị này nên bạn không thể xóa</p>";
19 }
20 break;
21 }
22 ?>
23
24 <?
25 if (isset($_POST['ButDel'])) {
26 $cnt=0;
27 foreach ($_POST['chk'] as $id)
28 {
29 if (CountRecord("products","dv_id=".$id)<=0)
30 @$result = mysql_query("delete from donvi where dv_id=".$id,$con);
31 if ($result) $cnt++;
32 }
33 echo "<p align=center class='err'>Đã xóa ".$cnt." phần tử</p>";
34 }
35 ?>
36 <?
37 $page = $_GET["page"];
38 $p=0;
39 if ($page!='') $p=$page;
40 $where="1=1";
41 ?>
42 <form method="POST" action="<? echo $_SERVER[PHP_SELF]; ?>" name="frmList">
43 <input type=hidden name="page" value="<? echo $page; ?>">
44 <?
45 function taotrang($sql,$link,$nitem,$itemcurrent)
46 { global $con;
47 $ret="";
48 $result = mysql_query($sql, $con) or die('Error' . mysql_error());
49 $value = mysql_fetch_array($result);
50 $plus = (($value['cnt'] % $nitem)>0);
51 for ($i=0;$i<($value[0] / $nitem) + plus;$i++)
52 {
53 if ($i<>$itemcurrent) $ret .= "<a href=\"".$link.$i."\" class=\"lslink\">".($i+1)."</a> ";
54 else $ret .= ($i+1)." ";
55 }
56 return $ret;
57 }
58 $pageindex=taotrang("select count(*) from donvi where $where","./?act=donvi_id&page=",$MAXPAGE,$page);
59 ?>
60
61 <table cellspacing="0" cellpadding="0" width="100%">
62 <tr>
63 <td class="smallfont">Trang : <? echo $pageindex; ?></td>
64 <td height="30" align="right" class="smallfont">
65 </td>
66 </tr>
67 </table>
68
69 <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#C9C9C9" width="100%" id="AutoNumber1">
70 <tr>
71 <td align=center nowrap class="title"><input type="checkbox" name="chkall" onclick="chkallClick(this);"></td>
72 <td nowrap class="title"> </td>
73 <td nowrap class="title"> </td>
74 <td align="center" nowrap class="title"><b>Mã</b></td>
75 <td align="center" nowrap class="title"><b>Tên đơn vị</b></td>
76 <td align="center" nowrap class="title"><b>Danh mục</b></td>
77
78 </tr>
79
80 <?
81 $sql="select * from donvi where $where and parent_id>0 limit ".($p*$MAXPAGE).",".$MAXPAGE;
82 $result=mysql_query($sql,$con);
83 $i=0;
84 while(($row=mysql_fetch_array($result)))
85 {
86 $i++;
87 if ($i%2) $color="#d5d5d5"; else $color="#e5e5e5";
88 ?>
89
90 <tr>
91 <td width="20" align="center" bgcolor="<? echo $color; ?>" class="smallfont">
92 <input type="checkbox" name="chk[]" value="<? echo $row['dv_id']; ?>"></td>
93 <td width="20" bgcolor="<? echo $color; ?>" class="smallfont">
94 <a href="./?act=donvi_id_m&page=<? echo $_REQUEST['page']; ?>&id=<? echo $row['dv_id']; ?>">Sửa</a></td>
95 <td width="20" bgcolor="<? echo $color; ?>" class="smallfont">
96 <a onclick="return confirm('Bạn có chắc chắn muốn xoá ?');" href="./?act=donvi_id&action=del&page=<? echo $_REQUEST['page']; ?>&id=<? echo $row['dv_id']; ?>">Xóa</a></td>
97 <td width="20" bgcolor="<? echo $color; ?>" align="left" width="55" align="left" class="smallfont"><? echo $row['town_id']; ?> </td>
98 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['dv_name']; ?> </td>
99 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['parent_id']; ?> </td>
100 </tr>
101 <?
102 }
103 ?>
104 </table>
105 <input type="submit" value="Xóa Chọn" name="ButDel" onclick="return confirm('Bạn có chắc chắn muốn xoá ?');" class="button" style="padding: 0">
106 <input type="hidden" name="act" value="donvi_id">
107 </form>
108 <script language="JavaScript">
109 function chkallClick(o) {
110 var form = document.frmList;
111 for (var i = 0; i < form.elements.length; i++) {
112 if (form.elements[i].type == "checkbox" && form.elements[i].name!="chkall") {
113 form.elements[i].checked = document.frmList.chkall.checked;
114 }
115 }
116 }
117 </script>
2 <tr align=center>
3 <td class="title" width="100%" height="17">
4 Danh mục đơn vị: <b> <a href="./?act=donvi_id_m&page=<? echo $_REQUEST['page']; ?>"><font color="#FFFFFF">Nhập
5 Mới</font></a><font color="#FFFFFF"> |</font></b></td>
6 </tr>
7 </table>
8 <?
9 switch ($_GET['action'])
10 {
11 case 'del' :
12 $id = $_GET['id'];
13 if (CountRecord("products","dv_id=".$id)<=0) {
14 @$result = mysql_query("delete from donvi where dv_id=".$id,$con);
15 if ($result) echo "<p align=center class='err'>Đã xóa thành công</p>";
16 else echo "<p align=center class='err'>Không thể xóa dữ liệu</p>";
17 } else {
18 echo "<p align=center class='err'>Đang có sản phẩm sử dụng đơn vị này nên bạn không thể xóa</p>";
19 }
20 break;
21 }
22 ?>
23
24 <?
25 if (isset($_POST['ButDel'])) {
26 $cnt=0;
27 foreach ($_POST['chk'] as $id)
28 {
29 if (CountRecord("products","dv_id=".$id)<=0)
30 @$result = mysql_query("delete from donvi where dv_id=".$id,$con);
31 if ($result) $cnt++;
32 }
33 echo "<p align=center class='err'>Đã xóa ".$cnt." phần tử</p>";
34 }
35 ?>
36 <?
37 $page = $_GET["page"];
38 $p=0;
39 if ($page!='') $p=$page;
40 $where="1=1";
41 ?>
42 <form method="POST" action="<? echo $_SERVER[PHP_SELF]; ?>" name="frmList">
43 <input type=hidden name="page" value="<? echo $page; ?>">
44 <?
45 function taotrang($sql,$link,$nitem,$itemcurrent)
46 { global $con;
47 $ret="";
48 $result = mysql_query($sql, $con) or die('Error' . mysql_error());
49 $value = mysql_fetch_array($result);
50 $plus = (($value['cnt'] % $nitem)>0);
51 for ($i=0;$i<($value[0] / $nitem) + plus;$i++)
52 {
53 if ($i<>$itemcurrent) $ret .= "<a href=\"".$link.$i."\" class=\"lslink\">".($i+1)."</a> ";
54 else $ret .= ($i+1)." ";
55 }
56 return $ret;
57 }
58 $pageindex=taotrang("select count(*) from donvi where $where","./?act=donvi_id&page=",$MAXPAGE,$page);
59 ?>
60
61 <table cellspacing="0" cellpadding="0" width="100%">
62 <tr>
63 <td class="smallfont">Trang : <? echo $pageindex; ?></td>
64 <td height="30" align="right" class="smallfont">
65 </td>
66 </tr>
67 </table>
68
69 <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#C9C9C9" width="100%" id="AutoNumber1">
70 <tr>
71 <td align=center nowrap class="title"><input type="checkbox" name="chkall" onclick="chkallClick(this);"></td>
72 <td nowrap class="title"> </td>
73 <td nowrap class="title"> </td>
74 <td align="center" nowrap class="title"><b>Mã</b></td>
75 <td align="center" nowrap class="title"><b>Tên đơn vị</b></td>
76 <td align="center" nowrap class="title"><b>Danh mục</b></td>
77
78 </tr>
79
80 <?
81 $sql="select * from donvi where $where and parent_id>0 limit ".($p*$MAXPAGE).",".$MAXPAGE;
82 $result=mysql_query($sql,$con);
83 $i=0;
84 while(($row=mysql_fetch_array($result)))
85 {
86 $i++;
87 if ($i%2) $color="#d5d5d5"; else $color="#e5e5e5";
88 ?>
89
90 <tr>
91 <td width="20" align="center" bgcolor="<? echo $color; ?>" class="smallfont">
92 <input type="checkbox" name="chk[]" value="<? echo $row['dv_id']; ?>"></td>
93 <td width="20" bgcolor="<? echo $color; ?>" class="smallfont">
94 <a href="./?act=donvi_id_m&page=<? echo $_REQUEST['page']; ?>&id=<? echo $row['dv_id']; ?>">Sửa</a></td>
95 <td width="20" bgcolor="<? echo $color; ?>" class="smallfont">
96 <a onclick="return confirm('Bạn có chắc chắn muốn xoá ?');" href="./?act=donvi_id&action=del&page=<? echo $_REQUEST['page']; ?>&id=<? echo $row['dv_id']; ?>">Xóa</a></td>
97 <td width="20" bgcolor="<? echo $color; ?>" align="left" width="55" align="left" class="smallfont"><? echo $row['town_id']; ?> </td>
98 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['dv_name']; ?> </td>
99 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['parent_id']; ?> </td>
100 </tr>
101 <?
102 }
103 ?>
104 </table>
105 <input type="submit" value="Xóa Chọn" name="ButDel" onclick="return confirm('Bạn có chắc chắn muốn xoá ?');" class="button" style="padding: 0">
106 <input type="hidden" name="act" value="donvi_id">
107 </form>
108 <script language="JavaScript">
109 function chkallClick(o) {
110 var form = document.frmList;
111 for (var i = 0; i < form.elements.length; i++) {
112 if (form.elements[i].type == "checkbox" && form.elements[i].name!="chkall") {
113 form.elements[i].checked = document.frmList.chkall.checked;
114 }
115 }
116 }
117 </script>